--
-- Host: localhost    Database: imagesdb
-- ------------------------------------------------------


--
-- Table structure for table `auth`
--

CREATE TABLE `auth` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `source` varchar(255) NOT NULL,
  `source_id` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk-auth-user_id-user-id` (`user_id`),
  CONSTRAINT `fk-auth-user_id-user-id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `auth`
--


--
-- Table structure for table `feed`
--

CREATE TABLE `feed` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `author_id` int(11) DEFAULT NULL,
  `author_name` varchar(255) DEFAULT NULL,
  `author_nickname` int(70) DEFAULT NULL,
  `author_picture` varchar(255) DEFAULT NULL,
  `post_id` int(11) DEFAULT NULL,
  `post_filename` varchar(255) NOT NULL,
  `post_description` text,
  `post_created_at` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `feed`
--

INSERT INTO `feed` VALUES (1,1023,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',125,'ad/91/3a37f8bedf238274a675a3f82d483d23b580.jpg','',1505391282),(2,1028,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',125,'ad/91/3a37f8bedf238274a675a3f82d483d23b580.jpg','',1505391282),(3,1022,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',125,'ad/91/3a37f8bedf238274a675a3f82d483d23b580.jpg','',1505391282),(4,1029,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',125,'ad/91/3a37f8bedf238274a675a3f82d483d23b580.jpg','',1505391282),(5,1026,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',125,'ad/91/3a37f8bedf238274a675a3f82d483d23b580.jpg','',1505391282),(6,1023,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',126,'7d/b6/fb9d98c602dc86601af356c169a2582f9d21.jpg','Show 1',1505394893),(7,1028,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',126,'7d/b6/fb9d98c602dc86601af356c169a2582f9d21.jpg','Show 1',1505394893),(8,1022,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',126,'7d/b6/fb9d98c602dc86601af356c169a2582f9d21.jpg','Show 1',1505394893),(9,1029,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',126,'7d/b6/fb9d98c602dc86601af356c169a2582f9d21.jpg','Show 1',1505394893),(10,1026,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',126,'7d/b6/fb9d98c602dc86601af356c169a2582f9d21.jpg','Show 1',1505394893),(11,1023,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',127,'c0/ee/b42337b7227ef25d40a27aee7169a9846858.jpg','Show 2',1505394903),(12,1028,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',127,'c0/ee/b42337b7227ef25d40a27aee7169a9846858.jpg','Show 2',1505394903),(13,1022,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',127,'c0/ee/b42337b7227ef25d40a27aee7169a9846858.jpg','Show 2',1505394903),(14,1029,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',127,'c0/ee/b42337b7227ef25d40a27aee7169a9846858.jpg','Show 2',1505394903),(15,1026,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',127,'c0/ee/b42337b7227ef25d40a27aee7169a9846858.jpg','Show 2',1505394903),(16,1023,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',128,'73/69/af7764121bb7134e2b50aed8c54aae2dc809.jpg','Snow is my name',1505394912),(17,1028,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',128,'73/69/af7764121bb7134e2b50aed8c54aae2dc809.jpg','Snow is my name',1505394912),(18,1022,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',128,'73/69/af7764121bb7134e2b50aed8c54aae2dc809.jpg','Snow is my name',1505394912),(19,1029,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',128,'73/69/af7764121bb7134e2b50aed8c54aae2dc809.jpg','Snow is my name',1505394912),(20,1026,1024,'Jon Snow',1024,'/img/profile_default_image.jpg',128,'73/69/af7764121bb7134e2b50aed8c54aae2dc809.jpg','Snow is my name',1505394912),(21,1023,1022,'Eddard \"Ned\" Stark',1022,'/img/profile_default_image.jpg',129,'23/69/95bfb7b967ab617df1243b11376456c95529.jpg','Ned 1',1505394929),(22,1024,1022,'Eddard \"Ned\" Stark',1022,'/img/profile_default_image.jpg',129,'23/69/95bfb7b967ab617df1243b11376456c95529.jpg','Ned 1',1505394929),(23,1029,1022,'Eddard \"Ned\" Stark',1022,'/img/profile_default_image.jpg',129,'23/69/95bfb7b967ab617df1243b11376456c95529.jpg','Ned 1',1505394929),(24,1023,1022,'Eddard \"Ned\" Stark',1022,'/img/profile_default_image.jpg',130,'55/c9/ede8ae87d282c0b37671ca88b9feee32c12e.jpg','Ned\'s Throne',1505394940),(25,1024,1022,'Eddard \"Ned\" Stark',1022,'/img/profile_default_image.jpg',130,'55/c9/ede8ae87d282c0b37671ca88b9feee32c12e.jpg','Ned\'s Throne',1505394940),(26,1029,1022,'Eddard \"Ned\" Stark',1022,'/img/profile_default_image.jpg',130,'55/c9/ede8ae87d282c0b37671ca88b9feee32c12e.jpg','Ned\'s Throne',1505394940),(27,1023,1022,'Eddard \"Ned\" Stark',1022,'/img/profile_default_image.jpg',131,'49/55/bd21d1e6ec1d6a82d95d638b2021913d9f0a.jpg','Guilty!',1505394950),(28,1024,1022,'Eddard \"Ned\" Stark',1022,'/img/profile_default_image.jpg',131,'49/55/bd21d1e6ec1d6a82d95d638b2021913d9f0a.jpg','Guilty!',1505394950),(29,1029,1022,'Eddard \"Ned\" Stark',1022,'/img/profile_default_image.jpg',131,'49/55/bd21d1e6ec1d6a82d95d638b2021913d9f0a.jpg','Guilty!',1505394950),(30,1022,1023,'Catelyn Stark',1023,'/img/profile_default_image.jpg',132,'0d/10/e9c010d4c4ff0211d13e0909622c17bfbe86.jpg','Look 1',1505394966),(31,1024,1023,'Catelyn Stark',1023,'/img/profile_default_image.jpg',132,'0d/10/e9c010d4c4ff0211d13e0909622c17bfbe86.jpg','Look 1',1505394966),(32,1029,1023,'Catelyn Stark',1023,'/img/profile_default_image.jpg',132,'0d/10/e9c010d4c4ff0211d13e0909622c17bfbe86.jpg','Look 1',1505394966),(33,1022,1023,'Catelyn Stark',1023,'/img/profile_default_image.jpg',133,'6d/41/ad06788186bd9a5e03e8c17aa0d79ac00143.jpg','Photoset',1505394979),(34,1024,1023,'Catelyn Stark',1023,'/img/profile_default_image.jpg',133,'6d/41/ad06788186bd9a5e03e8c17aa0d79ac00143.jpg','Photoset',1505394979),(35,1029,1023,'Catelyn Stark',1023,'/img/profile_default_image.jpg',133,'6d/41/ad06788186bd9a5e03e8c17aa0d79ac00143.jpg','Photoset',1505394979),(36,1027,1025,'Joffrey Baratheon',1025,'/img/profile_default_image.jpg',134,'91/e6/dcc7857648a24a60341474824d1a264db493.jpg','Wedding 1',1505395046),(37,1029,1025,'Joffrey Baratheon',1025,'/img/profile_default_image.jpg',134,'91/e6/dcc7857648a24a60341474824d1a264db493.jpg','Wedding 1',1505395046),(38,1027,1025,'Joffrey Baratheon',1025,'/img/profile_default_image.jpg',135,'a0/9c/442fa9515f34b13d39321f24eb73c7463ec3.jpg','Poison',1505395076),(39,1029,1025,'Joffrey Baratheon',1025,'/img/profile_default_image.jpg',135,'a0/9c/442fa9515f34b13d39321f24eb73c7463ec3.jpg','Poison',1505395076),(40,1027,1025,'Joffrey Baratheon',1025,'/img/profile_default_image.jpg',136,'e1/43/63b0421f2b1e6ee7b52effe5161debffa9a4.jpg','Weapons',1505395087),(41,1029,1025,'Joffrey Baratheon',1025,'/img/profile_default_image.jpg',136,'e1/43/63b0421f2b1e6ee7b52effe5161debffa9a4.jpg','Weapons',1505395087),(42,1028,1026,'Tyrion Lannister',1026,'/img/profile_default_image.jpg',137,'f5/8d/f06e0ff41f7c38227cd8afaf86529d58d5c9.jpg','',1505395101),(43,1025,1026,'Tyrion Lannister',1026,'/img/profile_default_image.jpg',137,'f5/8d/f06e0ff41f7c38227cd8afaf86529d58d5c9.jpg','',1505395101),(44,1024,1026,'Tyrion Lannister',1026,'/img/profile_default_image.jpg',137,'f5/8d/f06e0ff41f7c38227cd8afaf86529d58d5c9.jpg','',1505395101),(45,1029,1026,'Tyrion Lannister',1026,'/img/profile_default_image.jpg',137,'f5/8d/f06e0ff41f7c38227cd8afaf86529d58d5c9.jpg','',1505395101),(46,1028,1026,'Tyrion Lannister',1026,'/img/profile_default_image.jpg',138,'91/14/abf9f7044cdad161640a178603fd601be6e1.jpg','',1505395109),(47,1025,1026,'Tyrion Lannister',1026,'/img/profile_default_image.jpg',138,'91/14/abf9f7044cdad161640a178603fd601be6e1.jpg','',1505395109),(48,1024,1026,'Tyrion Lannister',1026,'/img/profile_default_image.jpg',138,'91/14/abf9f7044cdad161640a178603fd601be6e1.jpg','',1505395109),(49,1029,1026,'Tyrion Lannister',1026,'/img/profile_default_image.jpg',138,'91/14/abf9f7044cdad161640a178603fd601be6e1.jpg','',1505395109),(50,1028,1026,'Tyrion Lannister',1026,'/img/profile_default_image.jpg',139,'56/8a/608a00eec63bf114c4fcb5fd6d81f44663eb.jpg','',1505395114),(51,1025,1026,'Tyrion Lannister',1026,'/img/profile_default_image.jpg',139,'56/8a/608a00eec63bf114c4fcb5fd6d81f44663eb.jpg','',1505395114),(52,1024,1026,'Tyrion Lannister',1026,'/img/profile_default_image.jpg',139,'56/8a/608a00eec63bf114c4fcb5fd6d81f44663eb.jpg','',1505395114),(53,1029,1026,'Tyrion Lannister',1026,'/img/profile_default_image.jpg',139,'56/8a/608a00eec63bf114c4fcb5fd6d81f44663eb.jpg','',1505395114),(54,1025,1027,'Cersei Lannister',1027,'/img/profile_default_image.jpg',140,'94/3d/1bb723b88eecae17326ecf759c82306481e5.jpg','Shame day',1505395130),(55,1029,1027,'Cersei Lannister',1027,'/img/profile_default_image.jpg',140,'94/3d/1bb723b88eecae17326ecf759c82306481e5.jpg','Shame day',1505395130),(56,1025,1027,'Cersei Lannister',1027,'/img/profile_default_image.jpg',141,'f8/75/90465f57414ebbb9c728d50e129efb09d87d.jpg','Look at me',1505395137),(57,1029,1027,'Cersei Lannister',1027,'/img/profile_default_image.jpg',141,'f8/75/90465f57414ebbb9c728d50e129efb09d87d.jpg','Look at me',1505395137),(58,1024,1028,'Daenerys Targaryen',1028,'/img/profile_default_image.jpg',142,'ea/ed/48445d4538ccd1e1977324e0ca75efea852a.jpg','Friend zone',1505395154),(59,1029,1028,'Daenerys Targaryen',1028,'/img/profile_default_image.jpg',142,'ea/ed/48445d4538ccd1e1977324e0ca75efea852a.jpg','Friend zone',1505395154),(60,1026,1028,'Daenerys Targaryen',1028,'/img/profile_default_image.jpg',142,'ea/ed/48445d4538ccd1e1977324e0ca75efea852a.jpg','Friend zone',1505395154),(61,1024,1028,'Daenerys Targaryen',1028,'/img/profile_default_image.jpg',143,'8f/f5/fcca42aef186118b2ff3995e6a0bf0fd4c16.jpg','Warriors!',1505395165),(62,1029,1028,'Daenerys Targaryen',1028,'/img/profile_default_image.jpg',143,'8f/f5/fcca42aef186118b2ff3995e6a0bf0fd4c16.jpg','Warriors!',1505395165),(63,1026,1028,'Daenerys Targaryen',1028,'/img/profile_default_image.jpg',143,'8f/f5/fcca42aef186118b2ff3995e6a0bf0fd4c16.jpg','Warriors!',1505395165),(64,1024,1028,'Daenerys Targaryen',1028,'/img/profile_default_image.jpg',144,'a4/d4/d8aa4632e86405b7d88cecd21db00639d38c.jpg','Maps',1505395179),(65,1029,1028,'Daenerys Targaryen',1028,'/img/profile_default_image.jpg',144,'a4/d4/d8aa4632e86405b7d88cecd21db00639d38c.jpg','Maps',1505395179),(66,1026,1028,'Daenerys Targaryen',1028,'/img/profile_default_image.jpg',144,'a4/d4/d8aa4632e86405b7d88cecd21db00639d38c.jpg','Maps',1505395179);

--
-- Table structure for table `migration`
--

CREATE TABLE `migration` (
  `version` varchar(180) NOT NULL,
  `apply_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `migration`
--

INSERT INTO `migration` VALUES ('m000000_000000_base',1502886601),('m130524_201442_init',1502886603),('m170816_135114_create_auth_table',1502891510),('m170818_105615_alter_user_table',1503054099),('m170911_080253_create_post_table',1504103716),('m170914_101834_create_feed_table',1504105367);

--
-- Table structure for table `post`
--

CREATE TABLE `post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `description` text,
  `created_at` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `post`
--

INSERT INTO `post` VALUES (125,1024,'ad/91/3a37f8bedf238274a675a3f82d483d23b580.jpg',NULL,1505391282),(126,1024,'7d/b6/fb9d98c602dc86601af356c169a2582f9d21.jpg','Show 1',1505394893),(127,1024,'c0/ee/b42337b7227ef25d40a27aee7169a9846858.jpg','Show 2',1505394903),(128,1024,'73/69/af7764121bb7134e2b50aed8c54aae2dc809.jpg','Snow is my name',1505394912),(129,1022,'23/69/95bfb7b967ab617df1243b11376456c95529.jpg','Ned 1',1505394929),(130,1022,'55/c9/ede8ae87d282c0b37671ca88b9feee32c12e.jpg','Ned\'s Throne',1505394940),(131,1022,'49/55/bd21d1e6ec1d6a82d95d638b2021913d9f0a.jpg','Guilty!',1505394950),(132,1023,'0d/10/e9c010d4c4ff0211d13e0909622c17bfbe86.jpg','Look 1',1505394966),(133,1023,'6d/41/ad06788186bd9a5e03e8c17aa0d79ac00143.jpg','Photoset',1505394979),(134,1025,'91/e6/dcc7857648a24a60341474824d1a264db493.jpg','Wedding 1',1505395046),(135,1025,'a0/9c/442fa9515f34b13d39321f24eb73c7463ec3.jpg','Poison',1505395076),(136,1025,'e1/43/63b0421f2b1e6ee7b52effe5161debffa9a4.jpg','Weapons',1505395087),(137,1026,'f5/8d/f06e0ff41f7c38227cd8afaf86529d58d5c9.jpg',NULL,1505395101),(138,1026,'91/14/abf9f7044cdad161640a178603fd601be6e1.jpg',NULL,1505395109),(139,1026,'56/8a/608a00eec63bf114c4fcb5fd6d81f44663eb.jpg',NULL,1505395114),(140,1027,'94/3d/1bb723b88eecae17326ecf759c82306481e5.jpg','Shame day',1505395130),(141,1027,'f8/75/90465f57414ebbb9c728d50e129efb09d87d.jpg','Look at me',1505395137),(142,1028,'ea/ed/48445d4538ccd1e1977324e0ca75efea852a.jpg','Friend zone',1505395154),(143,1028,'8f/f5/fcca42aef186118b2ff3995e6a0bf0fd4c16.jpg','Warriors!',1505395165),(144,1028,'a4/d4/d8aa4632e86405b7d88cecd21db00639d38c.jpg','Maps',1505395179);


